package com.ys.gulimall.product.service.impl;

import com.alibaba.fastjson.TypeReference;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ys.common.constant.ProductConstant;
import com.ys.common.to.SkuHasStockVo;
import com.ys.common.to.SkuReductionTo;
import com.ys.common.to.SpuBoundTo;
import com.ys.common.to.es.SkuEsModel;
import com.ys.common.utils.PageUtils;
import com.ys.common.utils.Query;
import com.ys.common.utils.R;
import com.ys.gulimall.product.dao.SpuInfoDao;
import com.ys.gulimall.product.entity.*;
import com.ys.gulimall.product.feign.CouponFeignService;
import com.ys.gulimall.product.feign.SearchFeignService;
import com.ys.gulimall.product.feign.WareFeignService;
import com.ys.gulimall.product.service.*;
import com.ys.gulimall.product.vo.*;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;


@Service("spuInfoService")
public class SpuInfoServiceImpl extends ServiceImpl<SpuInfoDao, SpuInfoEntity> implements SpuInfoService {
	
	@Resource
	private SpuInfoDescService spuInfoDescService;
	
	@Resource
	private SpuImagesService spuImagesService;
	
	@Resource
	private AttrService attrService;
	
	@Resource
	private ProductAttrValueService productAttrValueService;
	
	@Resource
	private SkuInfoService skuInfoService;
	
	@Resource
	private SkuImagesService skuImagesService;
	
	@Resource
	private SkuSaleAttrValueService skuSaleAttrValueService;
	
	@Resource
	private CouponFeignService couponFeignService;
	
	@Resource
	private BrandService brandService;
	
	@Resource
	private CategoryService categoryService;
	
	@Resource
	private WareFeignService wareFeignService;
	
	@Resource
	private SearchFeignService searchFeignService;
	
	@Override
	public PageUtils queryPage(Map<String, Object> params) {
		IPage<SpuInfoEntity> page = this.page(
				new Query<SpuInfoEntity>().getPage(params),
				new QueryWrapper<SpuInfoEntity>()
		);
		
		return new PageUtils(page);
	}
	
	
	/**
	 * //TODO：高级部分完善后续
	 *
	 * @param vo 新增商品
	 */
	//@GlobalTransactional(rollbackFor = Exception.class)
	@Transactional(rollbackFor = Exception.class)
	@Override
	public void saveSupInfo(SpuSaveVo vo) {
		
		//1、保存spu基本信息：pms_spu_info
		SpuInfoEntity spuInfoEntity = new SpuInfoEntity();
		BeanUtils.copyProperties(vo, spuInfoEntity);
		spuInfoEntity.setCreateTime(new Date());
		spuInfoEntity.setUpdateTime(new Date());
		this.saveBaseSpuInfo(spuInfoEntity);
		
		//2、保存spu的描述图片：pms_spu_info_desc
		List<String> description = vo.getDescription();
		SpuInfoDescEntity spuInfoDescEntity = new SpuInfoDescEntity();
		spuInfoDescEntity.setSpuId(spuInfoEntity.getId());
		spuInfoDescEntity.setDescription(String.join(",", description)); // 将数组使用“,”拼接
		spuInfoDescService.saveSpuInfoDesc(spuInfoDescEntity);
		
		//3、保存spu的图片集：pms_spu_images
		List<String> images = vo.getImages();
		spuImagesService.saveImages(spuInfoEntity.getId(), images);
		
		//4、保存spu的规格参数：pms_product_attr_value
		List<BaseAttrs> baseAttrs = vo.getBaseAttrs();
		List<ProductAttrValueEntity> collect = baseAttrs.stream().map(attr -> {
			ProductAttrValueEntity valueEntity = new ProductAttrValueEntity();
			valueEntity.setAttrId(attr.getAttrId());
			
			//查询attr属性名
			AttrEntity byId = attrService.getById(attr.getAttrId());
			
			valueEntity.setAttrName(byId.getAttrName());
			valueEntity.setAttrValue(attr.getAttrValues());
			valueEntity.setQuickShow(attr.getShowDesc());
			valueEntity.setSpuId(spuInfoEntity.getId());
			return valueEntity;
		}).collect(Collectors.toList());
		productAttrValueService.saveProductAttr(collect);
		
		
		//5、保存spu的积分信息：gulimall_sms--->sms_spu_bounds
		Bounds bounds = vo.getBounds();
		SpuBoundTo spuBoundTo = new SpuBoundTo();
		BeanUtils.copyProperties(bounds, spuBoundTo);
		spuBoundTo.setSpuId(spuInfoEntity.getId());
		R r = couponFeignService.saveSpuBounds(spuBoundTo);
		
		if (r.getCode() != 0) {
			log.error("远程保存spu积分信息失败");
		}
		
		//5、保存当前spu对应的所有sku信息：pms_sku_info
		//5、1）、sku的基本信息:pms_sku_info
		List<Skus> skus = vo.getSkus();
		if (skus != null && skus.size() > 0) {
			skus.forEach(item -> {
				String defaultImg = "";
				for (Images image : item.getImages()) {
					if (image.getDefaultImg() == 1) {
						defaultImg = image.getImgUrl();
					}
				}
				
				SkuInfoEntity skuInfoEntity = new SkuInfoEntity();
				BeanUtils.copyProperties(item, skuInfoEntity);
				skuInfoEntity.setBrandId(spuInfoEntity.getBrandId());
				skuInfoEntity.setCatalogId(spuInfoEntity.getCatalogId());
				skuInfoEntity.setSaleCount(0L);
				skuInfoEntity.setSpuId(spuInfoEntity.getId());
				skuInfoEntity.setSkuDefaultImg(defaultImg);
				skuInfoService.saveSkuInfo(skuInfoEntity);
				
				Long skuId = skuInfoEntity.getSkuId();
				
				List<SkuImagesEntity> imagesEntities = item.getImages().stream().map(img -> {
					SkuImagesEntity skuImagesEntity = new SkuImagesEntity();
					skuImagesEntity.setSkuId(skuId);
					skuImagesEntity.setImgUrl(img.getImgUrl());
					skuImagesEntity.setDefaultImg(img.getDefaultImg());
					return skuImagesEntity;
				}).filter(entity -> {
					// 没有图片路径的无需保存
					//返回true就是需要，false就是剔除
					return !StringUtils.isEmpty(entity.getImgUrl());
				}).collect(Collectors.toList());
				
				//5、2）、sku的图片信息：pms_sku_images
				skuImagesService.saveBatch(imagesEntities);
				
				//5、3）、sku的销售属性：pms_sku_sale_attr_value
				List<Attr> attr = item.getAttr();
				List<SkuSaleAttrValueEntity> skuSaleAttrValueEntities = attr.stream().map(a -> {
					SkuSaleAttrValueEntity skuSaleAttrValueEntity = new SkuSaleAttrValueEntity();
					BeanUtils.copyProperties(a, skuSaleAttrValueEntity);
					skuSaleAttrValueEntity.setSkuId(skuId);
					return skuSaleAttrValueEntity;
				}).collect(Collectors.toList());
				
				skuSaleAttrValueService.saveBatch(skuSaleAttrValueEntities);
				
				//5、4）、sku的优惠、满减等信息：gulimall_sms--->sms_sku_ladder、sms_sku_full_reduction、sms_member_price
				SkuReductionTo skuReductionTo = new SkuReductionTo();
				BeanUtils.copyProperties(item, skuReductionTo);
				skuReductionTo.setSkuId(skuId);
				if (skuReductionTo.getFullCount() > 0 || skuReductionTo.getFullPrice().compareTo(BigDecimal.ZERO) == 1) {
					R r1 = couponFeignService.saveSkuReduction(skuReductionTo);
					if (r1.getCode() != 0) {
						log.error("远程保存sku积分信息失败");
					}
				}
			});
		}
		
	}
	
	@Override
	public void saveBaseSpuInfo(SpuInfoEntity spuInfoEntity) {
		
		this.baseMapper.insert(spuInfoEntity);
		
	}
	
	@Override
	public PageUtils queryPageByCondition(Map<String, Object> params) {
		
		QueryWrapper<SpuInfoEntity> queryWrapper = new QueryWrapper<>();
		
		String key = (String) params.get("key");
		if (!StringUtils.isEmpty(key)) {
			queryWrapper.and((wrapper) -> {
				wrapper.eq("id", key).or().like("spu_name", key);
			});
		}
		
		String status = (String) params.get("status");
		if (!StringUtils.isEmpty(status)) {
			queryWrapper.eq("publish_status", status);
		}
		
		String brandId = (String) params.get("brandId");
		if (!StringUtils.isEmpty(brandId) && !"0".equalsIgnoreCase(brandId)) {
			queryWrapper.eq("brand_id", brandId);
		}
		
		String catelogId = (String) params.get("catelogId");
		if (!StringUtils.isEmpty(catelogId) && !"0".equalsIgnoreCase(catelogId)) {
			queryWrapper.eq("catalog_id", catelogId);
		}
		
		IPage<SpuInfoEntity> page = this.page(new Query<SpuInfoEntity>().getPage(params), queryWrapper);
		
		return new PageUtils(page);
	}
	
	//@GlobalTransactional(rollbackFor = Exception.class)
	@Transactional(rollbackFor = Exception.class)
	@Override
	public void up(Long spuId) {
		
		//1、查出当前spuId对应的所有sku信息,品牌的名字
		List<SkuInfoEntity> skuInfoEntities = skuInfoService.getSkusBySpuId(spuId);
		
		//TODO 4、查出当前sku的所有可以被用来检索的规格属性
		List<ProductAttrValueEntity> baseAttrs = productAttrValueService.baseAttrListForSpu(spuId);
		
		List<Long> attrIds = baseAttrs.stream().map(attr -> {
			return attr.getAttrId();
		}).collect(Collectors.toList());
		
		List<Long> searchAttrIds = attrService.selectSearchAttrs(attrIds);
		//转换为Set集合
		Set<Long> idSet = new HashSet<>(searchAttrIds);
		
		List<SkuEsModel.Attrs> attrsList = baseAttrs.stream().filter(item -> {
			return idSet.contains(item.getAttrId());
		}).map(item -> {
			SkuEsModel.Attrs attrs = new SkuEsModel.Attrs();
			BeanUtils.copyProperties(item, attrs);
			return attrs;
		}).collect(Collectors.toList());
		
		List<Long> skuIdList = skuInfoEntities.stream()
				                       .map(SkuInfoEntity::getSkuId)
				                       .collect(Collectors.toList());
		//TODO 1、发送远程调用，库存系统查询是否有库存
		Map<Long, Boolean> stockMap = null;
		try {
			R skuHasStock = wareFeignService.getSkuHasStock(skuIdList);
			
			TypeReference<List<SkuHasStockVo>> typeReference = new TypeReference<List<SkuHasStockVo>>() {};
			stockMap = skuHasStock.getData(typeReference).stream().collect(Collectors.toMap(SkuHasStockVo::getSkuId, item -> item.getHasStock()));
		} catch (Exception e) {
			log.error("库存服务查询异常：原因{}", e);
		}
		
		//2、封装每个sku的信息
		Map<Long, Boolean> finalStockMap = stockMap;
		List<SkuEsModel> collect = skuInfoEntities.stream().map(sku -> {
			//组装需要的数据
			SkuEsModel esModel = new SkuEsModel();
			esModel.setSkuPrice(sku.getPrice());
			esModel.setSkuImg(sku.getSkuDefaultImg());
			
			//设置库存信息
			if (finalStockMap == null) {
				esModel.setHasStock(true);
			} else {
				esModel.setHasStock(finalStockMap.get(sku.getSkuId()));
			}
			
			//TODO 2、热度评分。0
			esModel.setHotScore(0L);
			
			//TODO 3、查询品牌和分类的名字信息
			BrandEntity brandEntity = brandService.getById(sku.getBrandId());
			esModel.setBrandName(brandEntity.getName());
			esModel.setBrandId(brandEntity.getBrandId());
			esModel.setBrandImg(brandEntity.getLogo());
			
			CategoryEntity categoryEntity = categoryService.getById(sku.getCatalogId());
			esModel.setCatalogId(categoryEntity.getCatId());
			esModel.setCatalogName(categoryEntity.getName());
			
			//设置检索属性
			esModel.setAttrs(attrsList);
			
			BeanUtils.copyProperties(sku, esModel);
			
			return esModel;
		}).collect(Collectors.toList());
		
		//TODO 5、将数据发给es进行保存：gulimall-search
		R r = searchFeignService.productStatusUp(collect);
		
		if (r.getCode() == 0) {
			//远程调用成功
			//TODO 6、修改当前spu的状态
			this.baseMapper.updateSpuStatus(spuId, ProductConstant.ProductStatusEnum.SPU_UP.getCode());
		} else {
			//远程调用失败
			//TODO 7、重复调用？接口幂等性:重试机制
		}
	}
	
	/**
	 * 根据skuId查询spu的信息
	 * @param skuId
	 * @return
	 */
	@Override
	public SpuInfoEntity getSpuInfoBySkuId(Long skuId) {

		//先查询sku表里的数据
		SkuInfoEntity skuInfoEntity = skuInfoService.getById(skuId);

		//获得spuId
		Long spuId = skuInfoEntity.getSpuId();

		//再通过spuId查询spuInfo信息表里的数据
		SpuInfoEntity spuInfoEntity = this.baseMapper.selectById(spuId);

		//查询品牌表的数据获取品牌名
		BrandEntity brandEntity = brandService.getById(spuInfoEntity.getBrandId());
		//spuInfoEntity.setBrandName(brandEntity.getName());

		return spuInfoEntity;
	}
	
}